EMT Practice Test

1. Question Content...

---

Question1: Which statement is FALSE regarding foreign keys?

Question2: Assume that you have completed the Register Tables wizard in SAS Data Integration Studio. Which
statement is true?

Question3: Within SAS Data Integration Studio's SQL Join transformation, the Validate Expression button is located
in:

Question4: When using the Table Loader transformation to load an existing target table that contains one or more
indexes in SAS Data Integration Studio, which statement is true?

Question5: The Platform Process Manager server is part of the Platform Suite for SAS. Which statement is FALSE
regarding the Platform Process Manager server?

Question6: A user needs to find out who has the SAS Data Integration Studio job "Create Tables" checked out. What
action should the user perform?

Question7: In SAS Data Integration Studio, where must the columns included in a business key exist?

Question8: In SAS Data Integration Studio, source table records and dimension table records are combined for output
using which transformation?

Question9: The profile reports generated in dfPower Profile jobs are viewed:

Question10: Which statement best describes the DataFlux Integration Server?

Question11: Which of the following is NOT defined as part of the New Library Wizard?

Question12: You want to create a job that checks conditions for your data before that data is loaded into a data
warehouse. The job should be able to detect error conditions such as missing data or duplicate data and
take appropriate actions like registering error conditions in log, etc. Which SAS Data Integration Studio
transformation should you use?

Question13: You want to register an external file with the following structure: first line contains Customer First and Last
Name second line is address 1 third line is address 2 fourth line contains the phone number. What action
should you take to read this file?

Question14: A SAS Data Integration Studio job was successfully scheduled and the appropriate event for triggering it
occurred. Which statement describes the situation correctly?

Question15: Assume that a SAS Data Integration Studio job is populating a table, and the table has metadata
definitions for two simple indexes. Which of the following is NOT a valid location for viewing which columns
are indexed?

Question16: In SAS Data Integration Studio, surrogate and retained key values are:

Question17: In SAS Data Integration Studio, primary keys, foreign keys and unique keys can be specified/defined in
which location?

Question18: Which statement regarding propagation is FALSE?

Question19: In SAS Data Integration Studio, the SCD Type 2 Loader transformation will do which of the following?

Question20: After creating a stored process from a SAS Data Integration Studio job, how can you test the stored
process to make sure it runs correctly?

Question21: SAS Data Integration Studio is dependent on which administration functions?

Question22: You want to create a table containing all customers from Italy. Assume that global customer order
information is available in a single table. Identify the SAS Data Integration Studio transformation that will
help you perform the task easily.

Question23: When using the Table Loader transformation in SAS Data Integration Studio to update an existing table
containing indexes or constraints, which statement is true?

Question24: Select the valid reasons for using SAS Data Integration Studio's Table Loader transformation. (Choose
two.)

Question25: In SAS Data Integration Studio, which statement is FALSE regarding status handling?

Question26: In SAS Data Integration Studio, which output format is supported for the default "out-of-the-box" job
report?

Question27: Within SAS Data Integration Studio, which one of the following is NOT an option available from the File->
New menu choice under External File grouping?

Question28: In SAS Data Integration Studio, which component allows the definition of job flows with dependencies
between different jobs?

Question29: How do you enable performance statistics for a SAS Data Integration Studio job?

Question30: The SAS Data Integration Studio SCD Type 2 Loader transformation performs which of the following?

Question31: Within SAS Data Integration Studio, automatic mappings are disabled for a job. A transformation has
defined source columns and defined target columns. One of the source columns, named COL1, is
character with a length of 50. One of the target columns, named COL1, is also character but of length 25.
What will happen if the COL1 columns are mapped?

Question32: When using the SCD Type 2 load method in SAS Data Integration Studio, which statement is true when a
change is detected?

Question33: In SAS Data Integration Studio, an index can be specified/defined in which location?

Question34: In the following display, can status handling be enabled for the Extract transformation?

Question35: Which statement correctly defines a System DSN?